﻿ALTER TABLE [dbo].[FlightSeats]
    ADD CONSTRAINT [PK_FlightSeats] PRIMARY KEY CLUSTERED ([FlightSeatId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF);

	GO
ALTER TABLE [dbo].[FlightSeats]
    ADD CONSTRAINT [UK_FlightSeats] UNIQUE NONCLUSTERED ([FlightId], [AircraftSeatId]) ;